package com.cnhis.cloudhealth.clinical.hosnurse.hosnewadvice.dao;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.stereotype.Repository;

import com.cnhis.cloudhealth.commons.dao.BaseDao;

@Repository
public class HosNewAdviceDao  extends BaseDao{

	  
	public int getBlp02(Map map) throws Exception {
		return (int) queryForExtObject("HosNewAdvice.getBlp02", map);
	}

	public Integer getBlp04(Map map) throws Exception {
		return (Integer) queryForExtObject("HosNewAdvice.getBlp04", map);
	}

	public Integer getVaa10(Map map) throws Exception {
		return (Integer) queryForExtObject("HosNewAdvice.getVaa10", map);
	}

	public int getVcj04Vcj05(Map map) throws Exception {
		return  (Integer) queryForExtObject("HosNewAdvice.getVcj04Vcj05", map);
	}

	public Map getMaxSalePara(Map map) throws Exception {
		return (Map) queryForExtObject("HosNewAdvice.getMaxSalePara", map);
	}

	public Map getMaxSale21Para(Map map) throws Exception {
		return (Map) queryForExtObject("HosNewAdvice.getMaxSale21Para", map);
	}

	public Map getMaxSale22Para(Map map) throws Exception {
		return (Map) queryForExtObject("HosNewAdvice.getMaxSale22Para", map);
	}

	public int getJudgeSsMz(List ls) throws Exception {
		return (Integer) queryForExtObject("HosNewAdvice.getJudgeSsMz", ls);
	}

	public String getJudgeMzfs(Map map) throws Exception {
		return (String) queryForExtObject("HosNewAdvice.getJudgeMzfs", map);
	}

	public String getJudgeNoZd(Map map) throws Exception {
		return (String) queryForExtObject("HosNewAdvice.getJudgeNoZd", map);
	}

	public int getBlpBlp0230() throws Exception {
		return (Integer) queryForExtObject("HosNewAdvice.getBlpBlp0230", null);
	}

	public String getJudgeNoQkdj(Map map) throws Exception {
		return (String) queryForExtObject("HosNewAdvice.getJudgeNoQkdj", map);
	}

	public int getJudNoTotal(Map map) throws Exception {
		return (Integer) queryForExtObject("HosNewAdvice.getJudNoTotal", map);
	}

	public int getJudLydy(Map map) throws Exception {
		return (Integer) queryForExtObject("HosNewAdvice.getJudLydy", map);
	}

	public String getJudgeKssYymd(Map map) throws Exception {
		return (String) queryForExtObject("HosNewAdvice.getJudgeKssYymd", map);
	}

	public List getJudgeOnlyXcy(Map map) throws Exception {
		return queryForList("HosNewAdvice.getJudgeOnlyXcy", map);
	}

	public String getJudgeXsje(Map map) throws Exception {
		return (String) queryForExtObject("HosNewAdvice.getJudgeXsje", map);
	}

	public String getJudgeXssl(Map map) throws Exception {
		return (String) queryForExtObject("HosNewAdvice.getJudgeXssl", map);
	}

	public Map getCviPara() throws Exception {
		return  (Map) queryForExtObject("HosNewAdvice.getCviPara", null);
	}

	public List getCviBrxmTmpCBM(Map map) throws Exception {
		return queryForList("HosNewAdvice.getCviBrxmTmpCBM", map);
	}

	public List getCviZz(Map map) throws Exception {
		return queryForList("HosNewAdvice.getCviZz", map);
	}

	public void insertCviCBM1(Map map) throws Exception {
		insert("HosNewAdvice.insertCviCBM1", map);
	}

	public void insertCviVbq1(List ls) throws Exception {
		insert("HosNewAdvice.insertCviVbq1", ls);
	}

	public void insertCviVaf1(Map map) throws Exception {
		insert("HosNewAdvice.insertCviVaf1", map);
	}

	public void insertCviVao1(Map map) throws Exception {
		insert("HosNewAdvice.insertCviVao1", map);
	}

	public void insertCviVbg1(Map map) throws Exception {
		insert("HosNewAdvice.insertCviVbg1", map);
	}

	public List getCviKbmBDJ(Map map) throws Exception {
		return  queryForList("HosNewAdvice.getCviKbmBDJ", map);
	}

	public void updateCviBdj1(Map map) throws Exception {
		update("HosNewAdvice.updateCviBdj1", map);
	}

	public List getCviInDbj(Map map) throws Exception {
		return queryForList("HosNewAdvice.getCviInDbj", map);
	}

	public void insertCviBdj1(List ls) throws Exception {
		insert("HosNewAdvice.insertCviBdj1", ls);
	}

	public void insertCviVax(List ls) throws Exception {
		insert("HosNewAdvice.insertCviVax", ls);
	}

	public void insertCviVaf(List ls) throws Exception {
		insert("HosNewAdvice.insertCviVaf", ls);
	}

	public Integer getCviHasVaa07(Map map) throws Exception {
		return (Integer) queryForExtObject("HosNewAdvice.getCviHasVaa07", map);
	}

	public void updateCviVcj1(Map map) throws Exception {
		update("HosNewAdvice.updateCviVcj1", map);
	}

	public void insertCviVcj1(Map map) throws Exception {
		insert("HosNewAdvice.insertCviVcj1", map);
	}

	public void updateCviFromMzpara370(Map map) throws Exception {
		update("HosNewAdvice.updateCviFromMzpara370", map);
	}
	public void insertCAM1(Map map)throws Exception{
		insert("HosNewAdvice.insertCAM1", map);
	}
	public void insertCAH1(Map map)throws Exception{
		insert("HosNewAdvice.insertCAH1", map);
	}

	public void addVBG1(Map map) throws Exception {
		insert("HosNewAdvice.addVBG1", map);
	}

	public void delVAF1ByCBM01(Map map) throws Exception {
		delete("HosNewAdvice.delVAF1ByCBM01", map);
	}

	public void delCBM1ByCBM01(Map map) throws Exception {
		delete("HosNewAdvice.delCBM1ByCBM01", map);
	}

	public void delVAO1ByCBM01(Map map) throws Exception {
		delete("HosNewAdvice.delVAO1ByCBM01", map);
	}

	public void delVBQ1ByCBM01(Map map) throws Exception {
		delete("HosNewAdvice.delVBQ1ByCBM01",map);
	}
	public List narcosisItemList(Map map)throws Exception{
		return queryForList("HosNewAdvice.narcosisItemList", map);
	}
	public List  checkOfficeProperty(Map map)throws Exception{
		return queryForList("HosNewAdvice.checkOfficeProperty", map);
	}
	public List getTreamentOffice(Map map)throws Exception{
		return queryForList("HosNewAdvice.getTreamentOffice", map);
	}

	public List<HashMap> getAllBLPList(Map map) throws Exception {
		return queryForList("HosNewAdvice.getAllBLPList",map);
	}

	public List<HashMap> execProc(String sqlId, HashMap temp) throws Exception {
		return queryForList(sqlId, temp);
	}

	public List execProc(Map temp) throws Exception {
		return queryForList("HosNewAdvice.execProc",temp);
	}
	public List getExamineType(Map map)throws Exception{
		return queryForList("HosNewAdvice.getExamineType", map);
	}
	public List getOfficeById(Map map)throws Exception{
		return queryForList("HosNewAdvice.getOfficeById", map);
	}
}
